FAQ about Setting Up Your Own Data

Do I have to make a new directory for each company I have?

No, one data directory can hold up to 99 companies. Everything is sorted under the company number you place it under. You can have separate data directories for each company if you want, but it is not necessary. The only advantage to having separate directories is when you Make a Backup of your data to the hard drive. Every time you make a temporary backup in Roughneck it overwrites the previous backup that was made. If you have separate directories you do not have to worry about backing up both companies to the same directory. You will have to have a separate backup directory for each of your data directories.

Why can't I enter Beginning Balances directly into the Company Chart of Accounts file?

Because they will not get posted to the Year to Date Transaction file. When you close a period the monthly transactions are moved to YTD transaction file. The Year to Date General Ledger is the supporting document for balances in the Company Chart of Accounts, and it reads from the YTD Transaction File.

Why do I need to use General Ledger, if I only use Roughneck for JIB's and Revenue Distribution?

Both of those operations depend on the coding of GL numbers to determine what is revenue and what is an expense. You couldn’t disburse revenue and expenses and update Operating Statements without the General Ledger.

Can I use the Deduction Fields in the Employee File for PreTax Deductions?

No, the deductions in the employee file are deductions taken out after taxes every pay period. You will need to go to File, Setup Options, and then Payroll Features and put a check mark in the ‘Use Pretax Deduction’ field. In the Employee File you can now use the Pretax Deduction field.

Can I use the same owner & vendor numbers for different companies?

Yes, you can have owner/vendor 10000 in company 01 and company 02. These two owner/vendor files will never touch each other. Their company number separates owners and vendors. You can even have a vendor and an owner within the same company with the same number. They will reside in two separate files, the owner file and the vendor file.

Can I use the same owner number for an owner who has a Royalty and Working interest?

No, the owner number must be different for the two different interests. The Working Interest owners have different minimum 1099 amounts than the Override and Royalty owners. They must be separated so their Government Form 1099’s are correct at the end of the year. Reference the IRS for additional information. Roughneck will not allow two of the same owner numbers on the same well.

What do I need to put as the Master Unit Number?

The master unit number is to group units together. Mainly used for profit and loss statements and dividing an Account Payable invoice to all of the units under that Master. All units must have the same master unit number to be grouped together for this purpose. If you do not require this you may leave the field blank.

What are Oklahoma County Codes?

These are 2 digit codes that are required for each well that is in Oklahoma. The county codes help determine which county a well is in. You can get these from the OK tax commission and they are required for Government Form 099.

Do I have to setup up 8 Division of Interest statuses for each owner on each unit?

You only have to set up one status for oil and one for gas if their percentages of ownership are different for each. If they have the same share of oil and gas you can use the same status for both. Choose the status/statuses you want to put your owner percentages on. Those status numbers must total to 100%. The other statuses can be used for other sales, different %’s and corrective entries.

What does Company Interest in the Division of Interest mean?

This is used to determine if this owner has any Company's interest in this Unit. Normally owner numbers from 99990 to 99999 are used for Company Interest. If this field is marked 'Y', the Revenue, Tax and Expense interest for each transaction status is used to calculate the P&L Report for the Company Interest. Values for the Company Interest P&L Report are stored in the Unit Chart of Accounts in the Company Interest boxes when you close your month.

How can I check my DOI to make sure it equals 100%?

Go into the Division of Interest and click on the tab that says Filter. Put in your company number and the unit number you want to check. Leave the owner number; suspense and owner type boxes blank. Click on Print/View in Unit Number Order. Click on Print Bottom Line Total Only. Click on the Set Filter button and then hit the print button on the tool bar.

This will print a report for that unit and total it at the bottom so you can see what the percentages add up to. If you want to check all units leave the unit number box blank on the filter page.

Can I change and add my own G/L numbers to the Company Chart of Accounts?

Yes, but there are some G/L numbers that need to remain in the Chart of Accounts. See GL Number Restrictions. Also, when it asks to change them in the Unit Chart of Accounts say yes. Any description can be changed.

What Transaction dates do I use when entering data?

The transaction date is the date you want to show something taking place in your books. Roughneck looks at transaction dates for almost everything it does. If you get a check today you enter the check with today’s transaction date if you want to show it hitting the books as of that day.

How do I setup prior suspense and minimum check withholding?

The Minimum check withhold revenue is put into the Min Check Withhold LTD box in the Owner/Customer file. Enter the dollar amount that you have withheld into this box. The next step is to Add Journal Entries. This is for the balances you have just entered (Ex: Debit 25300-Retained Earnings and Credit 21011-Min. Check Withheld). These journal entries will depend on what your CPA advises.

The Suspense Revenue balances are in the Division of Interest file. You will need to mark the box that says "Suspense" with a "Y" and put in their Beginning Suspense Date. Put their suspense revenue and tax into the LTD boxes for Net Revenue and Tax. Again you will need to Add Journal Entries (Ex: Debit 25300-Retained Earnings and Credit 21010-Suspense Withheld). Check with your CPA for the exact journal entries required.